Tabela LDescriptivePhraseAssignment

Definicja tabeli LDescriptivePhraseAssignment

Name

LDescriptivePhraseAssignment

Code

LDescriptivePhraseAssignment

Comment

Tabelka ta bedzie sluzyc do zapisu przynaleznosci frazy opisowej do Typu Danej opisowej, uzytkownika, typu uzytkownika, jednostki i uslugi.


Lista kolumn tabeli LDescriptivePhraseAssignment

Name

Code

LDescrPhraseAssignmentID

LDescrPhraseAssignmentID

DescriptivePhraseID

DescriptivePhraseID

DescriptivePhraseFormID

DescriptivePhraseFormID

DescriptiveDataTypeID

DescriptiveDataTypeID

FormDefinitionID

FormDefinitionID

AttributeID

AttributeID

PersonID

PersonID

UserTypeID

UserTypeID

ServID

ServID

ICD10Code

ICD10Code


Kolumna LDescrPhraseAssignmentID tabeli LDescriptivePhraseAssignment

Definicja kolumny LDescrPhraseAssignmentID tabeli LDescriptivePhraseAssignment

Name

LDescrPhraseAssignmentID

Code

LDescrPhraseAssignmentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DescriptivePhraseID tabeli LDescriptivePhraseAssignment

Definicja kolumny DescriptivePhraseID tabeli LDescriptivePhraseAssignment

Name

DescriptivePhraseID

Code

DescriptivePhraseID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DescriptivePhraseFormID tabeli LDescriptivePhraseAssignment

Definicja kolumny DescriptivePhraseFormID tabeli LDescriptivePhraseAssignment

Name

DescriptivePhraseFormID

Code

DescriptivePhraseFormID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DescriptiveDataTypeID tabeli LDescriptivePhraseAssignment

Definicja kolumny DescriptiveDataTypeID tabeli LDescriptivePhraseAssignment

Name

DescriptiveDataTypeID

Code

DescriptiveDataTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FormDefinitionID tabeli LDescriptivePhraseAssignment

Definicja kolumny FormDefinitionID tabeli LDescriptivePhraseAssignment

Name

FormDefinitionID

Code

FormDefinitionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AttributeID tabeli LDescriptivePhraseAssignment

Definicja kolumny AttributeID tabeli LDescriptivePhraseAssignment

Name

AttributeID

Code

AttributeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli LDescriptivePhraseAssignment

Definicja kolumny PersonID tabeli LDescriptivePhraseAssignment

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UserTypeID tabeli LDescriptivePhraseAssignment

Definicja kolumny UserTypeID tabeli LDescriptivePhraseAssignment

Name

UserTypeID

Code

UserTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServID tabeli LDescriptivePhraseAssignment

Definicja kolumny ServID tabeli LDescriptivePhraseAssignment

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ICD10Code tabeli LDescriptivePhraseAssignment

Definicja kolumny ICD10Code tabeli LDescriptivePhraseAssignment

Name

ICD10Code

Code

ICD10Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Domyslny kod ICD10 dla frazy opisowej.


Lista kluczy tabeli LDescriptivePhraseAssignment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LDescriptivePhraseAssignment

Definicja klucza Identifier_1 tabeli LDescriptivePhraseAssignment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment